﻿CREATE TABLE [dbo].[users] (
    [ID]            INT          IDENTITY (1, 1) NOT NULL,
    [Guid]          VARCHAR (36) NOT NULL,
    [UserName]      VARCHAR (45) NOT NULL,
    [Password]      VARCHAR (45) NOT NULL,
    [RealName]      VARCHAR (45) NOT NULL,
    [Mobile]        VARCHAR (45) NULL,
    [Status]        INT          DEFAULT ('0') NULL,
    [LastLoginTime] DATETIME     NULL,
    [LoginTryTimes] INT          NOT NULL,
    [CreatedOn]     DATETIME     NOT NULL,
    PRIMARY KEY CLUSTERED ([ID] ASC)
);

